Mysql8.0解决报错:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements |
您所在的位置:网站首页 › mysql 1193错误 › Mysql8.0解决报错:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements |
Mysql8.0解决报错:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements的问题:
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.26 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> create user zabbix@localhost identified by 'Linux112';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
可以看到如上报错:Your password does not satisfy the current policy requirements密码不符合要求 我们先看密码策略 mysql> SHOW VARIABLES LIKE 'validate_password%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | validate_password.check_user_name | ON | | validate_password.dictionary_file | | | validate_password.length | 8 | | validate_password.mixed_case_count | 1 | | validate_password.number_count | 1 | | validate_password.policy | MEDIUM | | validate_password.special_char_count | 1 | +--------------------------------------+--------+ 7 rows in set (0.01 sec)策略说明 validate_password.length 是密码的最小长度,默认是8,我们把它改成6 输入:set global validate_password.length=6; validate_password.policy 验证密码的复杂程度,我们把它改成0 输入:set global validate_password.policy=0; validate_password.check_user_name 用户名检查,用户名和密码不能相同,我们也把它关掉 输入:set global validate_password.check_user_name=off; mysql> set global validate_password.length=6; Query OK, 0 rows affected (0.00 sec) mysql> set global validate_password.policy=0; Query OK, 0 rows affected (0.00 sec) mysql> set global validate_password.check_user_name=off; Query OK, 0 rows affected (0.00 sec) mysql> create user zabbix@localhost identified by 'Linux112'; Query OK, 0 rows affected (0.01 sec)这样就能修改成功啦!! |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |